"foreign key" meaning in English

See foreign key in All languages combined, or Wiktionary

Noun

Forms: foreign keys [plural]
Head templates: {{en-noun}} foreign key (plural foreign keys)
  1. (databases) A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked. Wikipedia link: foreign key Categories (topical): Databases Related terms: referential integrity, primary key Translations (column referencing another table): 外鍵 (Chinese Mandarin), 外键 (wàijiàn) (Chinese Mandarin), cizí klíč [masculine] (Czech), viiteavain (Finnish), clé étrangère [feminine] (French), Fremdschlüssel [masculine] (German), 外部キー (gaibu kī) (Japanese), شناسال (Persian), chave estrangeira [feminine] (Portuguese), cheie străină [feminine] (Romanian), вне́шний ключ (vnéšnij ključ) [masculine] (Russian), främmande nyckel [common-gender] (Swedish), yabancı anahtar (Turkish)

Inflected forms

Alternative forms

{
  "forms": [
    {
      "form": "foreign keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "foreign key (plural foreign keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        {
          "kind": "other",
          "name": "English entries with incorrect language header",
          "parents": [
            "Entries with incorrect language header",
            "Entry maintenance"
          ],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Entries with translation boxes",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Japanese terms with redundant script codes",
          "parents": [
            "Terms with redundant script codes",
            "Entry maintenance"
          ],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with 1 entry",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with entries",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Czech translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Finnish translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with French translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with German translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Japanese translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Mandarin translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Persian translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Portuguese translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Romanian translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Russian translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Swedish translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Turkish translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        }
      ],
      "glosses": [
        "A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked."
      ],
      "id": "en-foreign_key-en-noun-AQKjHvlq",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "column",
          "column"
        ],
        [
          "relational",
          "relational"
        ],
        [
          "table",
          "table"
        ],
        [
          "identifies",
          "identifies"
        ]
      ],
      "raw_glosses": [
        "(databases) A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked."
      ],
      "related": [
        {
          "word": "referential integrity"
        },
        {
          "word": "primary key"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "translations": [
        {
          "code": "cmn",
          "lang": "Chinese Mandarin",
          "sense": "column referencing another table",
          "word": "外鍵"
        },
        {
          "code": "cmn",
          "lang": "Chinese Mandarin",
          "roman": "wàijiàn",
          "sense": "column referencing another table",
          "word": "外键"
        },
        {
          "code": "cs",
          "lang": "Czech",
          "sense": "column referencing another table",
          "tags": [
            "masculine"
          ],
          "word": "cizí klíč"
        },
        {
          "code": "fi",
          "lang": "Finnish",
          "sense": "column referencing another table",
          "word": "viiteavain"
        },
        {
          "code": "fr",
          "lang": "French",
          "sense": "column referencing another table",
          "tags": [
            "feminine"
          ],
          "word": "clé étrangère"
        },
        {
          "code": "de",
          "lang": "German",
          "sense": "column referencing another table",
          "tags": [
            "masculine"
          ],
          "word": "Fremdschlüssel"
        },
        {
          "code": "ja",
          "lang": "Japanese",
          "roman": "gaibu kī",
          "sense": "column referencing another table",
          "word": "外部キー"
        },
        {
          "code": "fa",
          "lang": "Persian",
          "sense": "column referencing another table",
          "word": "شناسال"
        },
        {
          "code": "pt",
          "lang": "Portuguese",
          "sense": "column referencing another table",
          "tags": [
            "feminine"
          ],
          "word": "chave estrangeira"
        },
        {
          "code": "ro",
          "lang": "Romanian",
          "sense": "column referencing another table",
          "tags": [
            "feminine"
          ],
          "word": "cheie străină"
        },
        {
          "code": "ru",
          "lang": "Russian",
          "roman": "vnéšnij ključ",
          "sense": "column referencing another table",
          "tags": [
            "masculine"
          ],
          "word": "вне́шний ключ"
        },
        {
          "code": "sv",
          "lang": "Swedish",
          "sense": "column referencing another table",
          "tags": [
            "common-gender"
          ],
          "word": "främmande nyckel"
        },
        {
          "code": "tr",
          "lang": "Turkish",
          "sense": "column referencing another table",
          "word": "yabancı anahtar"
        }
      ],
      "wikipedia": [
        "foreign key"
      ]
    }
  ],
  "word": "foreign key"
}
{
  "forms": [
    {
      "form": "foreign keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "foreign key (plural foreign keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "related": [
    {
      "word": "referential integrity"
    },
    {
      "word": "primary key"
    }
  ],
  "senses": [
    {
      "categories": [
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English multiword terms",
        "English nouns",
        "Entries with translation boxes",
        "Japanese terms with redundant script codes",
        "Pages with 1 entry",
        "Pages with entries",
        "Terms with Czech translations",
        "Terms with Finnish translations",
        "Terms with French translations",
        "Terms with German translations",
        "Terms with Japanese translations",
        "Terms with Mandarin translations",
        "Terms with Persian translations",
        "Terms with Portuguese translations",
        "Terms with Romanian translations",
        "Terms with Russian translations",
        "Terms with Swedish translations",
        "Terms with Turkish translations",
        "en:Databases"
      ],
      "glosses": [
        "A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "column",
          "column"
        ],
        [
          "relational",
          "relational"
        ],
        [
          "table",
          "table"
        ],
        [
          "identifies",
          "identifies"
        ]
      ],
      "raw_glosses": [
        "(databases) A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "foreign key"
      ]
    }
  ],
  "translations": [
    {
      "code": "cmn",
      "lang": "Chinese Mandarin",
      "sense": "column referencing another table",
      "word": "外鍵"
    },
    {
      "code": "cmn",
      "lang": "Chinese Mandarin",
      "roman": "wàijiàn",
      "sense": "column referencing another table",
      "word": "外键"
    },
    {
      "code": "cs",
      "lang": "Czech",
      "sense": "column referencing another table",
      "tags": [
        "masculine"
      ],
      "word": "cizí klíč"
    },
    {
      "code": "fi",
      "lang": "Finnish",
      "sense": "column referencing another table",
      "word": "viiteavain"
    },
    {
      "code": "fr",
      "lang": "French",
      "sense": "column referencing another table",
      "tags": [
        "feminine"
      ],
      "word": "clé étrangère"
    },
    {
      "code": "de",
      "lang": "German",
      "sense": "column referencing another table",
      "tags": [
        "masculine"
      ],
      "word": "Fremdschlüssel"
    },
    {
      "code": "ja",
      "lang": "Japanese",
      "roman": "gaibu kī",
      "sense": "column referencing another table",
      "word": "外部キー"
    },
    {
      "code": "fa",
      "lang": "Persian",
      "sense": "column referencing another table",
      "word": "شناسال"
    },
    {
      "code": "pt",
      "lang": "Portuguese",
      "sense": "column referencing another table",
      "tags": [
        "feminine"
      ],
      "word": "chave estrangeira"
    },
    {
      "code": "ro",
      "lang": "Romanian",
      "sense": "column referencing another table",
      "tags": [
        "feminine"
      ],
      "word": "cheie străină"
    },
    {
      "code": "ru",
      "lang": "Russian",
      "roman": "vnéšnij ključ",
      "sense": "column referencing another table",
      "tags": [
        "masculine"
      ],
      "word": "вне́шний ключ"
    },
    {
      "code": "sv",
      "lang": "Swedish",
      "sense": "column referencing another table",
      "tags": [
        "common-gender"
      ],
      "word": "främmande nyckel"
    },
    {
      "code": "tr",
      "lang": "Turkish",
      "sense": "column referencing another table",
      "word": "yabancı anahtar"
    }
  ],
  "word": "foreign key"
}

Download raw JSONL data for foreign key meaning in English (3.2kB)


This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2024-12-15 from the enwiktionary dump dated 2024-12-04 using wiktextract (8a39820 and 4401a4c). The data shown on this site has been post-processed and various details (e.g., extra categories) removed, some information disambiguated, and additional data merged from other sources. See the raw data download page for the unprocessed wiktextract data.

If you use this data in academic research, please cite Tatu Ylonen: Wiktextract: Wiktionary as Machine-Readable Structured Data, Proceedings of the 13th Conference on Language Resources and Evaluation (LREC), pp. 1317-1325, Marseille, 20-25 June 2022. Linking to the relevant page(s) under https://kaikki.org would also be greatly appreciated.